use [RDIFrameworkV2.9]

INSERT INTO szph.[RDIFrameworkV2.9].[dbo].[AdColumn]
           ([ColumnName]
           ,[Table_Id]
           ,[DbDataType]
           ,[IsNull]
           ,[FieldLength]
           ,[Preci]
           ,[Scale]
           ,[IsKey]
           ,[IsIdentifier]
           ,[Computed]
           ,[Description]
           ,[Caption]
           ,[ControlType]
           ,[SeqNo]
           ,[FormatPattern]
           ,[IsDispalyed]
           ,[Reference_Id]
           ,[LinkTable]
           ,[LinkColumn]
           ,[DefaultValue]
           ,[ValidationRule]
           ,[ValidationTips]
           ,[Panel]
           ,[Element_Id]
           ,[ColumnSql]
           ,[CaptionAlias]
           ,[Guid]
           ,[CreateDate]
           ,[Modify_Date]
           ,[Client]
           ,[Organization]
           ,[IsActive]
           ,[IsPKey])

select [ColumnName]
           ,[Table_Id]
           ,[DbDataType]
           ,[IsNull]
           ,[FieldLength]
           ,[Preci]
           ,[Scale]
           ,[IsKey]
           ,[IsIdentifier]
           ,[Computed]
           ,[Description]
           ,[Caption]
           ,[ControlType]
           ,[SeqNo]
           ,[FormatPattern]
           ,[IsDispalyed]
           ,[Reference_Id]
           ,[LinkTable]
           ,[LinkColumn]
           ,[DefaultValue]
           ,[ValidationRule]
           ,[ValidationTips]
           ,[Panel]
           ,[Element_Id]
           ,[ColumnSql]
           ,[CaptionAlias]
           ,[Guid]
           ,[CreateDate]
           ,[Modify_Date]
           ,[Client]
           ,[Organization]
           ,[IsActive]
           ,[IsPKey] from adcolumn a where not exists (select Table_Id,ColumnName from szph.[rdiframeworkv2.9].dbo.adcolumn b where a.Table_Id = b.Table_Id and a.ColumnName=b.ColumnName) and a.Table_Id !=24